What is PostgreSQL? Introduction

What is PostgreSQL? + Introduction

May 26, 2021 posted by Junior Kian Chong

In this tutorial, you will learn

--- What is PostgreSQL?

--- A Brief History of PostgreSQL

What is PostgreSQL?

PostgreSQL is an enterprise-class open source database management system. It supports both SQL and JSON for relational and non-relational queries for extensibility and SQL compliance. PostgreSQL supports advanced data types and performance optimization features, which are only available in expensive commercial databases, like Oracle and SQL Server. It is also known as Postgres.

It is backed by an experienced community of developers who have made tremendous contributions to make it a highly reliable DBMS system.

A Brief History of PostgreSQL

PostgreSQL (initially called Postgres) was created by a computer science professor Michael Stonebraker and his team. Today it has become one of the popular open-source databases.

Let's see some important Milestone from PostgreSQL History:

--- INGRES was developed-1977

--- Michael Stonebraker and his colleagues developed Postgres- 1986

--- Support for real ACID and PL/pgSQL - 1990

--- Released as Postgres95 in -1995

--- Re-released Postgres95 as PostgreSQL 6.0 - 1996

--- MVCC, GUC, Join syntax Controls and Procedural Language Loader added- 1998-2001

--- Version 7.2 to 8.2: Included features like Schema support, Nonblocking VACUUM, Roles and dblink – 2002-2006

--- PostgreSQL 8.4 released in 2009

--- PostgreSQL 9.0 released in 2010

--- NYCPUG (New York City PostgreSQL User Group) joins PgUS (United States PostgreSQL association)- 2013

--- PGconf organised-2014

Summary

--- Introduction to PostgreSQL: PostgreSQL is an enterprise-class open source database management system

--- PostgreSQL (initially called Postgres) was created by a computer science professor Michael Stonebraker and his team

--- One of the benefits of PostgreSQL is it's compatibility with various platforms using all major languages and middleware

Coding . PostgreSQL